Job Duties and Responsibilities:

• Requirements gathering and analysis by constant interactions with business team and with the client architects.
• Project planning and tracking the activities.
• Create and maintain conceptual, logical & physical Data model by understanding business data relationships.
• Create mapping documents, ETL design (HLD, LLD) documents and provide estimations.
• Work allocation within the team members, mentoring other ETL developers.
• Provide technical assistance, troubleshooting and identifying alternate development solutions.
• Develop code using PowerCenter Client Tools, Informatica IDQ, Informatica Intelligent Cloud Service (IICS), Oracle, Linux, Control-M and SQL Data Modeler.
• Extract data from different source systems and load into Data warehousing and Data mart.
• Develop the mappings, mapplets, tasks, reusable transformations, sessions and Workflows etc.
• Perform unit testing, integration testing and performance testing.
• Implement SCD Type 1 and SCD Type 2 mappings to maintain current and historical information in the Data Warehouse.
• Troubleshoot and provide support during load failures.
• Identify bottlenecks and implement Performance tuning
• Prepare release notes, deployment package and deployment tickets.
• Maintain versioning of each development release in SVN.
• Design and implement end to end Data Quality strategy including a sustainable Data Quality improvement lifecycle
• Create Data Quality Scorecards/Reports
• Perform data profiling and create rules using Informatica Analyst and Informatica Developer.
• Implement data quality processes using Standardizer, Address validator, Labeler, Match, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
• Migrate objects from IDQ to PowerCenter or other Informatica tools
• Perform code review
• Create new batch jobs and dependencies using Control-M/Autosys.
• Scheduling batch Jobs, testing it in the test environments and migrate into Production.
• Monitoring of scheduling and troubleshooting failed jobs and dependencies.
• Ability to work independently, lead and mentor the team
• Bring deep knowledge and experience in designing for and implementing solutions in the Cloud (AWS).

Work experience / Skills required for the position:

• 3+ years of experience in building software applications through ETL based technologies.
• Experience working with Informatica PowerCenter, Informatica Data Quality (IDQ), IICS, Oracle PL/SQL, Unix scripting and Control-M.
• Strong experience in relational database concepts, SQL, and procedural languages.
• Bring deep knowledge and experience in designing for and implementing solutions in the Cloud (AWS).
• Strong analytical and problem-solving skills as well as the ability to decompose complex problems and perform root cause analyses.
• Work in a collaborative environment.
• Experience working with the agile team tools (JIRA, Confluence, Scrum).
• Good knowledge in Agile/ Scrum and SDLC methodologies.

Technology aspects:

• Operating System : Windows 7/Windows 10, Unix/Linux
• ETL and DQ Tools : Informatica 8.x/9.x/10.x, Informatica Data Quality (IDQ) 9.x/10.x
• Cloud ETL Tool : Informatica CDI(IICS)
• Cloud Computing : AWS
• Database : Oracle 10g/11g/12c/19c, MS SQL Server 2008/2019, Sybase ASE 15.0.1
• Utilities : TOAD, Putty, WinSCP, SQL Developer, SQL Data Modeler, DBArtisan 9.0
• Languages : SQL, PL/SQL
• Scheduling Tool : Control-M, Autosys
• Versioning : SVN
• Other : Data Modelling, ETL designing