SQL, ETL with Informatica/ SSIS/ DataStage
We’re looking for Informatica or SSIS Engineers with Cloud Background (AWS, Azure)
Primary skills:
- Has played key roles in multiple large global transformation programs on business process management
- Experience in database query using SQL
- Should have experience working on building/integrating data into a data warehouse.
- Experience in data profiling and reconciliation
- Informatica PowerCenter/IBM-DataStage/ SSIS development
- Strong proficiency in SQL/PLSQL
- Good experience in performance tuning ETL workflows and suggest improvements.
- Developed expertise in complex data management or Application integration solution and deployment in areas of data migration, data integration, application integration or data quality.
- Experience in data processing, orchestration, parallelization, transformations and ETL Fundamentals.
- Leverages on variety of programming languages & data crawling/processing tools to ensure data reliability, quality & efficiency (optional)
- Experience in Cloud Data-related tool (Microsoft Azure, Amazon S3 or Data lake)
- Knowledge on Cloud infrastructure and knowledge on Talend cloud is an added advantage
- Knowledge of data modelling principles.
- Knowledge in Autosys scheduling Good experience in database technologies.
- Good knowledge in Unix system
Responsibilities:
- Need to work as a team member to contribute in various technical streams of Data integration projects.
- Provide product and design level technical best practices
- Interface and communicate with the onsite coordinators
- Completion of assigned tasks on time and regular status reporting to the lead
- Building a quality culture
- Use an issue-based approach to deliver growth, market and portfolio strategy engagements for corporates
- Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.
- Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint.
Qualification:
- BE/BTech/MCA (must) with an industry experience of 5-8 years.
- Experience in Talend jobs, joblets and customer components.
- Should have knowledge of error handling and performance tuning in Talend.
- Experience in big data technologies such as sqoop, Impala, hive, Yarn, Spark etc.
- Informatica PowerCenter/IBM-DataStage/ SSIS development
- Strong proficiency in SQL/PLSQL
- Good experience in performance tuning ETL workflows and suggest improvements.
- Atleast experience of minimum 3-4 clients for short duration projects ranging between 6-8 + months OR
- Experience of minimum 2+ clients for duration of projects ranging between 1-2 years or more than that
People with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.