Cloud Analytics Technologies LLC
Informatica Architect
Cloud Analytics Technologies LLC, Oklahoma City, Oklahoma, United States,
Domain Exposure: Manufacturing, Banking & Finance, Oil & Gas, IT/Software
Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs.Job DescriptionDescription:This position will sit within the development team onsite.This position seeks to fill the need for an Informatica /ETL developer.The individual selected for this role will be experienced in Informatica (9x/10x) and possess strong SQL and data warehousing skills as well as be well versed in the SDLC lifecycle processes.The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and support to meet the needs of the business.Individual should have experience with various databases platforms including (primary), Oracle, DB2 and SQL Server.Responsibilities:Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development.Implementing solutions using Informatica PowerCenter 9x/10x (Designer/Monitor).Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows.Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade systems.Work with ETL developers, business analysts, DBAs, system administrators, to architect data models, design and implement databases as well as write ETL related programs.Work closely with the team responsible for maintaining the data model.Document programming problems and resolutions for future reference.Job Requirements
At least 5-7 years’ experience in a large Data Warehouse environment.5-7 years’ experience in Informatica PowerCenter (9x/10x), focused on utilizing push down optimization, mapplets and worklets.Experience working complex transformations including update strategies, routers, normalizers etc.3-4 years’ experience in Linux/Unix.2-3 years’ experience with scheduling tools such as Autosys, etc.Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions.Excellent teamwork and collaboration skills.Proficient in shell scripting and performance tuning within a Unix/Linux Environment.Excellent written/verbal communications skills.Ability to meet deadlines with attention to detail and accuracy.Ability to handle multiple concurrent tasks/projects according to priorities.Ability to work in a group or team.Equal Opportunity Employer
Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.
#J-18808-Ljbffr
Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs.Job DescriptionDescription:This position will sit within the development team onsite.This position seeks to fill the need for an Informatica /ETL developer.The individual selected for this role will be experienced in Informatica (9x/10x) and possess strong SQL and data warehousing skills as well as be well versed in the SDLC lifecycle processes.The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and support to meet the needs of the business.Individual should have experience with various databases platforms including (primary), Oracle, DB2 and SQL Server.Responsibilities:Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development.Implementing solutions using Informatica PowerCenter 9x/10x (Designer/Monitor).Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows.Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade systems.Work with ETL developers, business analysts, DBAs, system administrators, to architect data models, design and implement databases as well as write ETL related programs.Work closely with the team responsible for maintaining the data model.Document programming problems and resolutions for future reference.Job Requirements
At least 5-7 years’ experience in a large Data Warehouse environment.5-7 years’ experience in Informatica PowerCenter (9x/10x), focused on utilizing push down optimization, mapplets and worklets.Experience working complex transformations including update strategies, routers, normalizers etc.3-4 years’ experience in Linux/Unix.2-3 years’ experience with scheduling tools such as Autosys, etc.Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions.Excellent teamwork and collaboration skills.Proficient in shell scripting and performance tuning within a Unix/Linux Environment.Excellent written/verbal communications skills.Ability to meet deadlines with attention to detail and accuracy.Ability to handle multiple concurrent tasks/projects according to priorities.Ability to work in a group or team.Equal Opportunity Employer
Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.
#J-18808-Ljbffr