Job Description
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.x
- Excellent Communication and analytic skills
- Good 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 Methodology
- Perform 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 design
- Coordinate and interact with the On-site / Off-shore team to clarify on requirements / issues if any
- Perform 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 deliverables
- Ensure adherence to Guardian Security, Compliance and Development Standards for work deliverables.
- Co-ordination with the Guardian SME's and participate in knowledge transition sessions
- Establish, maintain, and enforce ETL design principles, techniques, standards, and best practices
- Drive 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 abends
- Work closely with other teams – DBA’s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abends
- Work 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 capacity
- Ability 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
