SeniorAdministrator - Extract Transform Load (ETL),… at HCLTech · IN

Job Summary

This individual contributor is primarily responsible for translating business requirements and functional specifications into software solutions, for assisting in contributing to and leveraging the technical direction for the development of integrated business and/or enterprise application solutions, and for providing consultation to help ensure new and existing software solutions are developed.

1. 3 years Hands-on experience with Databricks platform, including Delta Lake and Lakehouse architecture.\
   \\
2. 3 years in Python in developing and debugging code, with a focus on data manipulation and processing.\
   \\
3. 3 years experience with data structures, data modeling, ETL/ELT concepts, and data warehousing principles.\
   \\
4. 3 years experience with SQL skills for data querying and manipulation. Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating and assigning resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks, as appropriate; and recognizing and capitalizing on improvement opportunities. • Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback. • As part of the IT Engineering job family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multi-channel, high-volume, high-transaction, on/offpremise, cloud-based solutions. • Provides insight into recommendations for technical solutions that meet design and functional needs. • Translates business requirements and functional specifications into physical program designs, code modules, stable application systems, and software solutions by partnering with Business Analysts and other team members to understand business needs and functional specifications. • Assists in identification of specific interfaces, methods, parameters, procedures, and functions, as required, to support technical solutions. • Leads systems' incident support and troubleshooting for complex and non-complex issues. • Supports component integration testing (CIT) and user acceptance testing (UAT) for application initiatives by providing triage, attending test team meetings, keeping the QC up-to-date, performing fixes and unit testing, providing insight to testing teams in order to ensure the appropriate depth of test coverage, and supporting the development of proper documentation. • Builds and maintains trusting relationships with internal customers and third party vendors to ensure the alignment, buyin, and support of diverse project stakeholders. • Reviews and validates technical specifications and documentation. • Identifies specific interfaces, methods, parameters, procedures, and functions to support technical solutions while incorporating architectural designs. • Collaborates with architects and/or software consultants to ensure functional specifications are converted into flexible, scalable, and maintainable solution designs. •

Key Responsibilities

NA

Skill Requirements

1. 3 years in using Azure Data Factory for data ingestion, transformation, and orchestration. 2. 3 years with the Azure ecosystem, including services like Azure Data Lake Storage, Azure Blob Storage, and Azure SQL Database 3. 3 years of software development lifecycle, agile methodologies, CI/CD, and version control systems (e.g., Git). 4. Understanding of data governance principles, data quality, and security best practices 5. 3 years in designing and developing ETL processes using Informatica IICS. Experience with Informatica Intelligent Cloud Services, including its CAI (Cloud Application Integration) and CDI (Cloud Data Integration) modules.

Other Requirements

Minimum three (3) years experience working on project(s) involving the implementation of solutions applying development life cycles (e.g., SDLC). • Minimum one (1) year in a technical lead role with or without direct reports. • Bachelor's degree in Computer Science, CIS, or related field and Minimum six (6) years experience in software development or a related field. Additional equivalent work experience may be substituted for the degree requirement.