Job Description :
Job Location: Irving, TX Start Date: ASAP (Immediate) Candidate should have worked last 5-10 years in Telecom Domain Job Description Job Title: Data Architect / ETL Architect JOB DUTIES: Captures business requirements and rules, designs build and maintains the associated conceptual, logical and physical models to support the business requirements in a dynamic, expanding business environment. Creates and maintains all required documentation to support, communicate, and validate the data model. As a Senior Data Architect, considers and balances the requirements of transaction systems, business intelligence and reporting. Builds and establishes the Data Lineage for all the business user usage related entities. Generates Lineage Reports and publishes to business team that provides details on how data flow from source systems into Authoritative Data store and further into Authoritative Data Access Layers and ultimately into consumer reporting. Supports & provides recommendations to Enterprise wide projects that includes migration, integration, ETL,storage and archiving, warehousing, management, data mining and analytics. Builds and maintains Technical Metadata and Business Metadata. Publishes and conducts model reviews with business and technical project teams. Coordinates with development/implementation team to improve model formats and approaches with regard to implementation issues. For projects related to Big Data analytics in Hadoop environment, perform modelling of Hadoop environment and build Data Standards for Data Ingestion, Data processing in Authoritative Data Store (ADS Layer) and Data visualization in the ADAL (Authoritative Data Access Layer) Layer. Participates in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization Architects with an eye toward high performance, scalability, and high availability. Identifies growing data needs & provides recommendations to Enterprise Architect & Data Governance counsel in terms of Master Data Management & Big Data implementations. Identifies and provides recommendations to Data Governance counsel with regards to the Data replication strategies for big data volumes. Supports and become a bridge amongst business teams, data engineering and reporting teams. ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments. Designing and building large data warehouses with very strong data analysis skills Experience in documentation of Technical Metadata & Business Metadata and conduct review with technical and business teams periodically. Hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools. Experience in support & provide recommendations to Enterprise wide projects that includes migration, integration, ETL, storage and archiving, warehousing, management, data mining and analytics. Hands-on experience in Data Management Initiatives such as Data Masking, Metadata management, Data Quality for assessing all Quality related aspects on the Data Warehouse Data & build foundation for Data Steward activities. Experience with advanced SQL query techniques using TOAD, SQL Navigator, SQL Assistance. Must have good understanding of leading 3rd party products in the relevant areas (e.g. Informatica, Talend, Data stage, Business Objects, Micro strategy or equivalent Significant experience with System Development Life Cycle (SDLC MUST HAVE SKILLS: 1.At least 5 years working experience Data Architecture 2. Knowledge on design and development best practices in data warehouse environments 3. Experience in large scale distributed computing systems 4. Knowledge of Hadoop ecosystem and its components - HBase, Pig, Hive, Sqoop, Flume, Oozie, etc. 5. Experience with integration of data from multiple data sources 6. Strong in SQL, PL/SQL, ETL & Python is a MUST. Talend experience desired 7. Should last 5-10 years working in Telecom Indusrty 8. Bachelor's or higher degree, or the equivalent, related to this field of work (information technology/software development DESIRED SKILLS: 1. Erwin modeling 2. Micro strategy 3. Understanding Dimensional modeling 4. Devops implementation knowledge 5. Git Commands