Job Description:The major responsibility of this role is to do BI & DWH project implementations using ETL tools – Informatica/ SyncSort, Postgresql/Oracle. He/she is responsible for guiding the team and sharing knowledge with them. Candidate will be responsible for successful deployment and support of the code. He/she will be responsible for guiding and mentoring team members and new hires.Qualifications:

The major responsibility of this role is to do BI & DWH project implementations using ETL tools – Informatica/ SyncSort, Postgresql/Oracle. He/she is responsible for guiding the team and sharing knowledge with them. Candidate will be responsible for successful deployment and support of the code. He/she will be responsible for guiding and mentoring team members and new hires.

Competencies/Skills: Individual Contributor Competencies

Skills:       

5-7 years of hands-on and good experience in ETL tools – Informatica PowerCenter 10.xExcellent Communication and analytic skillsGood Understanding of Data Warehousing and Data Modelling and be able to interpret logical, physical data models, conceptual models, and ER Diagrams.Knowledge of SAFe Agile MethodologyPerform hands-on design and development activities for Extract Transform and Load (ETL) tasks using Guardian approved tools like Informatica and Syncsort and adept at performing impact analysis for ETL changes.Perform hands-on development activities using PostgreSQL and Oracle DB. Should be having good knowledge on writing complex SQL.Perform hands-on UNIX, PL/SQL development and perform Unit testing for all deliverables.Experience with ETL and query performance optimization, technical analysis, and solution designCoordinate and interact with the On-site / Off-shore team to clarify on requirements / issues if anyPerform all applicable SDLC activities for the work items assigned including requirement analysis, impact analysis and effort estimations.Perform initial analysis of tasks, perform effort estimations based on Guardian standards, assign and monitor work queues.Provide Review, Testing support and production deployment and post-production (warranty) support for work deliverablesEnsure adherence to Guardian Security, Compliance and Development Standards for work deliverables.Co-ordination with the Guardian SME's and participate in knowledge transition sessionsEstablish, maintain, and enforce ETL design principles, techniques, standards, and best practicesDrive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and provide ongoing support.Resolve any Application defects or Job abendsWork closely with other teams – DBA’s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abendsWork on creating steady state deliverables and provide clarifications required for timely Production incident resolution and carrying out On Call Level 2 Production support activities for supported applications Responsible for proof-of-concept of new approaches and ideas, technology evaluation, maintain the As Is data architecture, develop To Be and transition architecture.Self-motivated and ability to work on his/her individual capacityAbility to identify automation opportunities and implement automation

Technology: 

Informatica, PostgreSQL, UNIX, SQL, Querying using HIVE, PRESTO, Spark, understanding of Data Warehousing and Data Modelling, Oracle, SQL Server, DB2, UDB, HADOOP, AWS EMR, Python

Education and Experience:

Education:    B.Tech Computers/MCA

Experience:  5 to 7 years in development projects with BI/ DWH background.

Location:

This position can be based in any of the following locations:

Gurgaon

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday