Role name: Developer Role Description:
• Experience in ETL Informatica, SQL.
• Experience in shell scripting/ Agile environment.
• Hands-on experience in performance tuning for complex ETL Mappings.
• Should be good in Complex mapping design, Mapplet design, workflow design & scheduling.
• Should have knowledge on various transformations used in Informatica like - Joiner, Normalizer, Lookup, Filter, Router, Custom transformation etc.
• Should have experience in publishing data from semi structured data like XML & Jason.
• Experienced in ETL concepts and tools such as Informatica PowerCenter, SQL, Data Mapping, XML, Web Services.
• Experience in scripting languages like Batch, Shell.
• Experience with integration of data from multiple data sources like DB2, Oracle, SQL server.
• Tests, debugs, and documents ETL processes, SQL queries.
• Ability to gather, analyze, prioritize and present requirements.
• Strong with SQL development knowledge for Relational Databases.
• Hands on with SQL tuning with Explains, query plans etc.
• Experience in Agile Scrum Methodology for Software development.
• Experience in the Banking domain.
• Should have experience on scheduling tools like Autosys.
• Must possess strong written & verbal communication skills with Stakeholders.
• Experience in Production and On call support. Competencies: Digital : Data Governance, Digital : Informatica Data Quality (IDQ) Experience (Years): 8-10 Essential Skills:
• Experience in ETL Informatica, SQL.
• Experience in shell scripting/ Agile environment.
• Hands-on experience in performance tuning for complex ETL Mappings.
• Should be good in Complex mapping design, Mapplet design, workflow design & scheduling.
• Should have knowledge on various transformations used in Informatica like - Joiner, Normalizer, Lookup, Filter, Router, Custom transformation etc.
• Should have experience in publishing data from semi structured data like XML & Jason.
• Experienced in ETL concepts and tools such as Informatica PowerCenter, SQL, Data Mapping, XML, Web Services.
• Experience in scripting languages like Batch, Shell.
• Experience with integration of data from multiple data sources like DB2, Oracle, SQL server.
• Tests, debugs, and documents ETL processes, SQL queries.
• Ability to gather, analyze, prioritize and present requirements.
• Strong with SQL development knowledge for Relational Databases.
• Hands on with SQL tuning with Explains, query plans etc.
• Experience in Agile Scrum Methodology for Software development.
• Experience in the Banking domain.
• Should have experience on scheduling tools like Autosys.
• Must possess strong written & verbal communication skills with Stakeholders.
• Experience in Production and On call support. Desirable Skills:
• Experience in ETL Informatica, SQL.
• Experience in shell scripting/ Agile environment.
• Hands-on experience in performance tuning for complex ETL Mappings.
• Should be good in Complex mapping design, Mapplet design, workflow design & scheduling.
• Should have knowledge on various transformations used in Informatica like - Joiner, Normalizer, Lookup, Filter, Router, Custom transformation etc.
• Should have experience in publishing data from semi structured data like XML & Jason.
• Experienced in ETL concepts and tools such as Informatica PowerCenter, SQL, Data Mapping, XML, Web Services.
• Experience in scripting languages like Batch, Shell.
• Experience with integration of data from multiple data sources like DB2, Oracle, SQL server.
• Tests, debugs, and documents ETL processes, SQL queries.
• Ability to gather, analyze, prioritize and present requirements.
• Strong with SQL development knowledge for Relational Databases.
• Hands on with SQL tuning with Explains, query plans etc.
• Experience in Agile Scrum Methodology for Software development.
• Experience in the Banking domain.
• Should have experience on scheduling tools like Autosys.
• Must possess strong written & verbal communication skills with Stakeholders.
• Experience in Production and On call support. Country: United States Branch City Location: TCS - Rockville,MD
McLean
McLean, V
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Date Posted: 31 March 2025
Apply for this Job