Informatica /ETL/Python developer

Company: Randstad
Location: Charlotte, North Carolina, United States
Type: Full-time
Posted: 01.APR.2021

Summary

Informatica /ETL/Python developer**job details:**+ location:Charlotte, NC+ salary:$55 - $65 per hour+ date posted:Thursday, March 25, 2021+ ...

Description

Informatica /ETL/Python developer**job details:**+ location:Charlotte, NC+ salary:$55 - $65 per hour+ date posted:Thursday, March 25, 2021+ job type:Contract+ industry:Finance and Insurance+ reference:829950**job description**Informatica /ETL/Python developerjob summary:**Summary:**+ This position will sit within the Treasury Data Technology Group within Client. This position seeks to fill the need for an Informatica /ETL/Python developer. The individual selected for this role will be experienced in Informatica (10x) and possess SQL and data warehousing skills as well as be well versed in the Agile 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 Oracle Exadata (primary), Teradata and SQL Server. The individual will sit within a scrum team and will work closely with an on-shore product lead and developers as well as off-shore developers and testers. The individual would also be expected to work on potential new technology stacks for the application.**Duties and Responsibilities Essential Functions:**+ Demonstrates expertise in a variety of the fields concepts, practices, and procedures related to ETL/Data design and development. Implementing solutions using Informatica PowerCenter 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 system Work with ETL developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs. Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry.+ Document programming problems and resolutions for future reference. Candidate will be 'naturally curious' with an inclination towards evaluating contemporary tools and technologies in support of continuously improving the platform. Experience At least 5-7 years experience in a large Data Warehouse environment.+ 5-7 years experience in Informatica PowerCenter (10x), focused on utilizing push down optimization, mapplets and worklets. Experience working complex transformations including update strategies, routers, normalizers etc. Expert SQL writing/tuning 3-4 years experience in Linux/Unix 3-4 years experience in relational databases Oracle Exadata preferred 3-4 years experience in Python scripting. Additionally, experience in other open source scripting will be considered. 2-3 years experience with scheduling tools such as Autosys, TIDAL etc understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).+ 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 environment Experience working at financial institutions in the global finance and markets domainlocation: CHARLOTTE, North Carolinajob type: Contractsalary: $55 - 65 per hourwork hours: 8am to 5pmeducation: Bachelorsresponsibilities:+ Demonstrates expertise in a variety of the fields concepts, practices, and procedures related to ETL/Data design and development. Implementing solutions using Informatica PowerCenter 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 system Work with ETL developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs. Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry.+ Document programming problems and resolutions for future reference. Candidate will be 'naturally curious' with an inclination towards evaluating contemporary tools and technologies in support of continuously improving the platform. Experience At least 5-7 years experience in a large Data Warehouse environment.+ 5-7 years experience in Informatica PowerCenter (10x), focused on utilizing push down optimization, mapplets and worklets. Experience working complex transformations including update strategies, routers, normalizers etc. Expert SQL writing/tuning 3-4 years experience in Linux/Unix 3-4 years experience in relational databases Oracle Exadata preferred 3-4 years experience in Python scripting. Additionally, experience in other open source scripting will be strongly considered. 2-3 years experience with scheduling tools such as Autosys, TIDAL etc strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).qualifications:+ Experience level: Experienced+ Minimum 10 years of experience+ Education: Bachelorsskills:+ ETL+ Informatica+ PythonEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

 
Apply Now

Share

Flash-bkgn
Loader2 Processing ...