Data / ETL Informatica developer

Trident Consulting is seeking a

• At least 7 years’ experience developing enterprise class data pipelines using Informatica PowerCenter, MS SQL Server, Control M.
• Good understanding of the Data warehousing concepts, SQL server, Oracle SQL, or any other database SQL expertise.
• Understand the business needs that translate them into a scalable, automated solution.
• Designing processes that can extract/receive data from various heterogeneous source systems
• Design, develop, test, and support new capabilities and ongoing changes within the various application data marts
• Experience writing complex SQL queries, SQL Tuning and knowledge of database design and development (SQL and TSQL)
• Create a ETL data flow diagrams based on the business requirements and pseudo logic.
• Building capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File, JSON)
• Architecting and supporting ETL and data load processes
• Perform data cleansing and transforming the data according to business rules
• At least 2 years of experience working in Agile - Scrum teams
• Developing reusable frameworks for data extraction, loading and cleansing
• Strong technical background covering ETL environments with PowerCenter, Shell scripting, python.
• Design, develop, test, and support new capabilities and ongoing changes within the various application data marts
• Should work with the multiple teams to understand the requirements, Design, Develop and test the interfaces
• Should have experience with Unit and Integration Testing process
• Strong Data Warehousing skills including Data profiling, Data masking, Auditing in ETL.
• Experience extracting data from a variety of sources, and a desire to expand those skills (SQL server, Oracle)
• Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts
• Update the team on a daily or weekly basis in case of any project blockers and red flags
• Provide performance improvement related guidance for scalability and reusability of code and data objects.
• Apply specialized knowledge in assembly or integration, cross-discipline functions, knowledge engineering, industry expertise, or legacy evolution
• Should have good coordination skills and Data Analysis skills.
• Should have experience with Unit and Integration Testing process
• Raise software access requests to any database servers, tools and SharePoint portals required for the project.