Senior ETL Developer - Informatica Job at iVoyant, Atlanta, GA

OWludUVlaFdlWk40TVYzL0NHUmlqMDF0eGc9PQ==
  • iVoyant
  • Atlanta, GA

Job Description

About the job Senior ETL Developer - Informatica iVoyant is looking for multiple Informatica Senior developers to join our client Digital Team. The Informatica Senior developer will work with the client functional SMEs within the Digital and the Business team to understand the requirements and prepare technical design. They will ensure the availability and validity of the data to ensure that it fits with the requested business rules. The Informatica Senior developer will create and maintain the Source-to-Target data mappings, Logical and Physical Data Model and, business and technical test cases to ensure data quality. In addition, they will also assist in developing the data pipeline (using Informatica BDM or Python) to ensure ongoing data collection, consolidation, and management. The Informatica Senior developer will aid in the optimization of operations by manipulating and aggregating the disparate data sources into a format that is easily digestible by both data scientists and statistically adept colleagues. Their core responsibility will be to combine large volumes of disparate complex data, conduct quality checks on the data, manipulate the data and ensure continuous access to a clean format of the operational data for data scientists and other stakeholders. Responsibilities Take ownership of the Functional Data Domain assigned to the Data Engineer. Gather knowledge of the business, functions, and their data analysis needs along with business's relationship with the Data. Work with Functional team to understand requirements, data sources and business rules. Identify, Analyze and Profile the data across various source systems to understand and ensure that data fits the business requirements. Raise any data anomalies and work with the functional users to close any anomalies or data gaps. Identify relationships across multiple source systems; and create reference data with the help of data stewards. Finalize the technical Source-to-Target mapping to develop the data pipelines from source systems to the dimensional model. Work with the team of Developer(s) for the technical implementation of the Data Pipelines. Ensure that the Unit and Integration tests complete successfully. Drive the QA/UAT with the Functional users and ensure a deployment to higher environments. Supports maintenance, bug fixing and performance analysis along data pipeline Qualifications Deep working experience of SQL, databases and table's structure to query the data from various places, integrate and present the results to the business Deep working experience of ETL, data pipelines using Informatica (DEI/BDM) or equivalent technologies. Willing to work with cross-functional teams to meet a common goal Strong critical thinking and problem solving skills Required Skills Deep working experience of SQL, databases and tables structure to query the data from various places, integrate and present the results to the business Deep working experience of ETL, data pipelines using Informatica (DEI/BDM) or equivalent technologies. Willing to work with cross-functional teams to meet a common goal Strong critical thinking and problem solving skills Other Skills Knowledge of Big Data platforms (e.g. Hadoop, Map/Reduce, Spark, HBase, HDInsight, Data Bricks, Hive) and with programming languages like UNIX shell scripting, Python etc. Knowledge of with reporting and BI packages e.g., PowerBI, Tableau, SAP BO etc. Education Bachelor's Degree in Computer Science, Engineering, and/or background in Mathematic and Statistics; Master's or other advanced degree a plus

Job Tags

Work experience placement,

Similar Jobs

Compass Group

FOOD TRANSPORTER/DELIVERY DRIVER (FULL TIME) Job at Compass Group

 ...Food Transporter/Delivery Driver We are hiring immediately for full time FOOD TRANSPORTER/DELIVERY DRIVER positions. Location: Los Alamos HS - Los Alamos, NM 87544 Note: online applications accepted only. Schedule: Full time schedule; Monday - Friday. Hours may... 

Wyndy LLC

Family in Homewood, AL requires a dependable babysitter. Job at Wyndy LLC

 ...At 1pm, it will just be the 3yr old. The other two kids will walk home from school about 3pm. Kids can eat a snack and play outside. All 3 kids enjoy playing with the neighbors in the front yards. Qualifications A love of working with children Excellent communication... 

Avis Budget Group

Fleet Driver/Transporter - FT Job at Avis Budget Group

 ...Unhappy in your ride-hailing or delivery driver role? Were now seeking responsible...  ...following our processes and driving our cars safely. Perks Youll Get: Bi-weekly...  ...$270 as a tax-free benefit for public transportation or parking expenses Retirement benefits... 

Northern Illinois Hospice

Massage Therapist - Part-Time Job at Northern Illinois Hospice

 ...Make a Difference With Every Touch Join Us as a Part-Time Massage Therapist in DeKalb/Sycamore area! If youre a Massage Therapist who...  ...clinical team, support families during vulnerable moments, and experience the kind of impact only hospice care can offer. Every visit... 

Honda Motor Company

Equipment Service Technician - Anna Engine Plant - $5,000 Sign On and Relocation Assistance Job at Honda Motor Company

 ...emergency downtime, troubleshoot for the root cause of the failure, and repair as needed in a timely manner Perform preventive maintenance activity both during production and non-production time Document daily activity in the Computerized Maintenance Management...