Sr Specialist Data/AI Engineering (ETL-Informatica, SQL, Snowflake & Kafka)

Job Description

:

Experience: Typically requires 9-12 years experience.

Role & Responsibilities

• Works directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applications.
• Determines and documents data mapping rules for movement of medium to high complexity data between applications.
• Adheres to and promotes the use of data administration standards.
• Supports data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts.
• Creates and sustains processes, tools, and on-going support structures and processes. Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function.
• Creates and populates meta-data into repositories.
• May create data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models. May also create data flow diagrams and process models and integrates models across functional areas and platforms.
• Works closely with DBAs to transition logical models to physical implementation. May be responsible for employing data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis.
• May also be responsible for quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance.

Required Skills:

• Full life-cycle experience on enterprise software development projects.
• Experience with Snowflake, Databricks, Hadoop and fluent with SQL, Postgres SQL, Vertica, Evenhub, Goldengate, Mongo DB and data analysis techniques.
• Experience with AI/ML & Python would be an added advantage.
• Experience in any of the databases SQL (MySQL, Postgres SQL) and NoSQL (Mongo DB, Cassandra, Azure Cosmos DB), Distributed Databases or Big Data (Apache Spark, Cloudera, Vertica), Databricks
• Snowflake Certification would be an added advantage.
• Extensive experience in ETL, shell or python scripting, data modelling, analysis, and preparation
• Experience in Unix/Linux system, files systems, shell scripting.
• Good to have knowledge on any cloud platforms like AWS, Azure, Snowflake, etc.
• Good to have experience in BI Reporting tools – Power BI or Tableau
• Good problem-solving and analytical skills used to resolve technical problems.
• Ability to work independently but must be a team player. Should be able to drive business decisions and take ownership of their work.
• Experience in presentation design, development, delivery, and good communication skills to present analytical results and recommendations for action-oriented data driven decisions and associated operational and financial impacts.
• Sharp technical troubleshooting skills.
• Experience in presentation design, development, delivery, and communication skills to present analytical results and recommendations for action-oriented data-driven decisions and associated operational and financial impacts.
• Keep up-to-date with developments in technology and industry norms can help you to produce higher-quality results.
• Flexible to work from office 3 days (in a week) from 1 pm to 10 pm

#SoftwareEngineering

Weekly Hours:

40

Time Type:

Regular

Location:

IND:KA:Bengaluru / Innovator Building, Itpb, Whitefield Rd - Adm: Intl Tech Park, Innovator Bldg

It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities. AT&T is a fair chance employer and does not initiate a background check until an offer is made.