Etl Architect

2 days ago

Gurgaon, India Augusta Infotech Full time

**Hiring, ETL Architect**

Key Accountabilities

Experience and Qualifications Required
- B.E./ B.Tech / MCA, FULL time course only
- 10-14 years of overall IT experience.

Essential Skills:

- Architecting, Planning and Implementation of end-to-end Data Warehouse and Business Intelligence systems utilizing best practices from Data Architecture, Data Integration and Data Management areas.
- Expert Data Modeling skills: entity-relationship as well as dimensional, design experience of staging area, data warehouses, data marts and ODS, at least 4+ years
- Data Analysis, Source System Analysis and Data Mapping to Target Data Model
- Extensive knowledge in in Data Integration architecture / ETL / Data warehouse, esp large and complex data warehouses, at least 8+ years

- Good experience with Oracle 11g/12c databases including thorough understanding of Partitioning, Indexing, Archiving, Materialized Views, at least 2+ years
- Knowledge of Unix and shell scripting and scheduling tools (control-M or autosys) is preferred, at least 2+ years
- At least 1+ years of experience of working in Data Virtualization platforms, like Denodo or CISCO Information Server and understanding of logical Data warehouses/Data Vaults.
- Hands-on experience on the Snowflake implementation, Data Ingestion patterns, Data Models, Data Quality framework etc.
- Understanding of row and column level security, data masking concepts; role and access privileges
- Work as a single point of technical contact for the Delivery team while providing the requisite levels of support required for delivering the project through the development and testing phases.
- Strong understanding of Oracle BI server, Oracle BI Answers, BI interactive Dashboards, Smartview, Oracle BI Publisher.
- Some exposure to Reporting tools like OBIEE, BO or Tableau and concept of Semantic layer
- Experience of Infrastructure considerations, like sizing, server configuration, DR strategies, load balancing would be an advantage
- Ability to guide/mentor juniors in the team and review code artefacts
- Excellent communication (verbal and written) and interpersonal skills suitable for a diverse audience, with the ability to communicate in a positive, friendly and effective manner with ‘technical’ or ‘non-technical’ users/ customers
Desirable Skills
- Informatica B2B Data Transformation tool experience or experience loading pdf/excel
- Experience using other ETL tools like Kettle or Talend.
- Integration with Cloud systems like Salesforce, Marketo, etc.
- Experience modelling and using NOSQL Databases, preferably Cassandra
- Experience of working in Big Data Technology stack and Advanced Analysis
- Exposure and sound knowledge of Financial Services domain - Mutual Funds and Fund Accounting would be definitive plus
- Proven ability to work well under pressure and in a team environment.
- Self-motivated, flexible, responsible, and a penchant for quality
- Ability to work closely with cross-functional teams.
- Ability to prioritise own activities, work under hard deadlines.

**Required Skills and Experience**:
Industry:
IT/Computers-Software

Role:
ETL Architect

key Skills:
ETL, Data Modeling, Data Architecture, Data Integration, PL-SQL, SQL, Talend, Business Intelligence, BI, Kettle

Education:
B.Sc/B.Com/M.Sc/MCA/B.E/B.Tech

  • ETL Developer

    6 days ago

    Gurgaon, Haryana, India American Express Global Business Travel Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Amex GBT is a place where colleagues find inspiration in travel as a force for good and – through their work – can make an impact on our industry. We're here to help our colleagues achieve success and offer an inclusive and collaborative culture where your voice is valued.We are looking for an experienced Data ETL Developer / BI Engineer who loves...

  • Data Architect

    4 days ago

    Gurgaon, Haryana, India beBeeData Full time ₹ 1,50,00,000 - ₹ 2,50,00,000

    Job Overview">As a Data Architect, you will design and develop data solutions that facilitate the generation, collection, and processing of data.Key Responsibilities:">Design, develop, and maintain scalable data pipelines to ensure seamless data flow and integrity.Implement ETL processes to migrate and deploy data across various systems.Collaborate with...

  • Cloud Data Architect

    13 minutes ago

    Gurgaon, Haryana, India beBeeSnowflake Full time ₹ 20,00,000 - ₹ 30,00,000

    Cloud Data ArchitectWe are seeking a highly skilled and experienced Cloud Data Architect to design, implement, and optimize our cloud data warehousing solutions.Lead the design and implementation of enterprise-wide Snowflake solutions, ensuring best practices in data modeling, architecture, and security.Collaborate with business stakeholders, data engineers,...

  • Data Systems Architect

    5 hours ago

    Gurgaon, Haryana, India beBeeDataSpecialist Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Opportunity:We are seeking an experienced Integration Specialist with expertise in designing, developing and maintaining enterprise data integration solutions using ETL tools.The role involves creating scalable ETL processes that transform, load and manage data across systems for analytics, reporting and operational needs.Key Responsibilities:Design and...

  • Cloud Data Architect

    1 hour ago

    Gurgaon, Haryana, India beBeeData Full time ₹ 1,50,00,000 - ₹ 2,50,00,000

    Job OverviewWe are seeking a skilled Data Architect to design, develop, and optimize data pipelines and solutions using Snowflake.The ideal candidate should have strong expertise in cloud-based data warehousing, SQL, ETL processes, and integration with modern data platforms.Key Responsibilities:Design, develop, and maintain Snowflake-based data warehouse...

  • Solution Architect

    3 weeks ago

    Gurgaon, Haryana, India amdocs Full time

    Organizational Level 1 Amdocs Services Organizational Level 2 CBS Americas Manager Mohammed Kaleem Farooq Location India- Gurgaon Amdocs Site Talent Acquisition Ritu Anil Navle Required Travel Minimal Open to Relocation Relocation - No Referral Bonus Reward Amount INR35 000 00 In case this job is open for Amdocs employees only Refer...

  • Data Migration Architect

    2 weeks ago

    Gurgaon, Haryana, India BLJ Tech Geeks Full time

    About the Role :We are seeking a highly skilled Data Migration Architect to lead the design, planning, and execution of complex data migration initiatives. The ideal candidate will have extensive experience in data architecture, ETL processes, cloud/on-premise migration, and database technologies. This role requires a blend of technical expertise, strategic...

  • Application Solutions Architect

    5 days ago

    Gurgaon, Haryana, India beBeeData Full time ₹ 18,00,000 - ₹ 21,00,000

    Job Title:Application Solutions ArchitectAbout the RoleThis position is for an Application Solutions Architect who will work with various stakeholders to design applications that meet business needs and requirements.The ideal candidate will have a strong understanding of data integration and ETL processes, experience in designing and implementing data...

  • Cloud Data Architect

    5 days ago

    Gurgaon, India Maven Wave Full time

    Architect, design, develop and deploy end-to-end data analytics solutions in the Cloud for our clients! We are looking for a Cloud Data Architect to be responsible for leading a team of engineers and consultants to deliver technical solutions from architecture through deployment. **Your Life As a Maven**: Perform overall architecture design, performance...

  • Data Architect Position

    4 days ago

    Gurgaon, Haryana, India beBeeData Full time ₹ 15,00,000 - ₹ 20,00,000

    Senior Data Architect We are seeking a seasoned Senior Data Architect to lead the design and implementation of our data warehousing and analytics solutions. Job Description The ideal candidate will have extensive experience in building and managing large-scale data pipelines, utilizing technologies such as Apache Kafka, Storm, Spark, or AWS Lambda. A strong...