EY - GDS Consulting - AI and DATA -ETL - SSIS - Senior
Job description
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
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 | Building a better working world
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.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.