-
Corp-Corp
-
W2-Permanent
-
W2-Contract
-
Contract to Hire
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 14th Mar 2023
- Senior ETL developer# SSIS, and Strong experience on SQL server, Linux Unix scripting.
- 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 T SQL)
- 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)
- 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