Job Summary: 

• Participate in the requirement-gathering process and develop complex sources to target mapping rules
• Conduct Data Profiling in support of the design and testing processes
• Create ETL design documents that support best practices and development standards
• Contribute to the development of best practice documents and ensure adherence to best practices
• Create a tagging strategy for optimum reusability and performance
• Integrate data from multiple source systems into Data Warehouse using SCD type 1 and type 2 approaches
• Participate in architectural decisions for data integration from source to staging to ODS to AFDW
• Create ETL flows to Integrate the On-Prem data to Cloud Snowflake warehouse using Nifi/PySpark/SnowSql
• Configure EC2 Clusters, S3 Buckets, EMR and other AWS services needed for AFDW
• Involved in developing and maintaining Scheduling and Sequence jobs with complex dependencies.
• Troubleshooting jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Use relevant test types and develop test strategy for all data integration scenarios.

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Profiling (Hard Skills)
• Cloud Data Integration (Hard Skills)
• AWS Configuration (Hard Skills)
• Performance Tuning (Hard Skills)
• Requirement Gathering (Soft Skills)
• Problem-Solving (Soft Skills)
• Architectural Decision-Making (Soft Skills)

Job Summary: 

• Reporting to the Head of Data Management, the Senior ETL Developer is responsible for the design, development and maintenance of data and reporting marts and zones and the data transformations from the Enterprise Data Warehouse (EDW), Marts and downstream consuming applications.
• Designing and developing architectures for efficient and scalable data transformations inbound to the EDW and outbound to consuming data stores and systems within Azure and the BP Enterprise Data Architecture
• Provides subject matter expertise in addressing projects and issues that encompass a wide range of internal and external systems (Core banking, Wealth, Trust, Data Warehousing), components, and processes
• Work closely with DART members such as Data Analysts, Report Developers, QA, Release Management and other software engineers to develop and release new capabilities as well as research technical requirements and resolve issues
• Troubleshoot and resolve technical issues with data migration and transformation within the Microsoft Azure environment such as DataBricks, Data Factory, bespoke code, and other applications in the Development. 
• Test and Production environments.
• Ensure the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle, especially from Data Lake through downstream data delivery and reporting
• Implement code changes and follow DART's control process including code check-in, code reviews, jira issue updates
• Leverages industry best practices data transformation and processing techniques, tools and coding languages, data models, query optimizations & analytics, shares same with team
• Extend and maintain the EDW/Mart zone such that enables self-service capabilities for business power users to self-upload, analyze and report on governed data assets
• Serve as lead developer on the DART Data Governance technical working group to ensure all standards and policies are implemented, maintained and enforced
• Provide weekly data integrity reporting to the Data Governance technical working group for the EDW and Data Marts to ensure integrity standards are actively monitored

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Architecture (Hard Skills)
• Azure Services (Hard Skills)
• Data Security (Hard Skills)
• Troubleshooting (Hard Skills)
• Teamwork (Soft Skills)
• Problem-Solving (Soft Skills)
• Communication (Soft Skills)

Job Summary: 

• Work as an individual contributor to develop code and support the team on deliverables.
• Participate in Post Release Reviews to ensure all lessons learned on technical things are documented and incorporated in future releases/projects
• Closely work with Project/Release managers & support them in all activities during the entire life cycle of the project
• Work closely with the Application team on the Issues resolution and application Knowledge Transitions.
• Partner with the other VCC functions for technical-related topics, and imbibe them into the deliverables
• Support conceptual technical solutions, evaluate & implement new technologies/tools
• Build the ETL Code using Abinitio for both Batch and real-time approaches as per business requirements.
• Automate the resiliency process for achieving complete restart ability and recoverability of the load processes with zero data loss
• Extract, transform, and load data from various Databases, Sequential files, and XML documents.
• Coordinate with the offshore development team and mentor developers on proper usage of the DataStage tool and adoption of best practices and standards.
• Maintain metadata at appropriate levels commensurate with best practices

Skills on Resume: 

• ETL Development (Hard Skills)
• DataStage (Hard Skills)
• Data Integration (Hard Skills)
• Automation (Hard Skills)
• Technical Support (Hard Skills)
• Team Collaboration (Soft Skills)
• Mentoring (Soft Skills)
• Problem-Solving (Soft Skills)