US Citizen
H1B Work Permit
Corp-Corp
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 11th Mar 2023
At least 8-9+ 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.
Responsibilities:
Required Skills:
· Advanced SQL Server Expert Level Informatica PowerCenter 10x Control M, Bitbucket
· University degree from a well-respected academic institution; advanced degrees in Information management, Computer Science, and/or other professional certifications are a plus.
· At least 8-9+ years of hands-on experience in design and development of enterprise class data pipelines using tools like Informatica PowerCenter 10.x and above, SQL Server, Control M.
· Strong knowledge of ETL pipeline design, Data Warehousing, Data Marts, and Operational data stores (ODS).
· Experience writing complex SQL queries and SQL Tuning and strong knowledge of database design and development (SQL and NoSQL)
Nice to Have
Any cloud experience on AWS, Azure, and snowflake with any relevant certification